---
title: TableObject.PreserveColumnInfo Property (Excel)
keywords: vbaxl10.chm916082
f1_keywords:
- vbaxl10.chm916082
ms.prod: excel
ms.assetid: eb9c65b5-587d-375c-0655-9bf78ce3dc85
ms.date: 06/08/2017
---


# TableObject.PreserveColumnInfo Property (Excel)

Specifies if column sorting, filtering, and layout information is preserved whenever a query table is refreshed. The default value is  **False** . **Boolean** Read/Write


## Syntax

 _expression_ . **PreserveColumnInfo**

 _expression_ A variable that represents a[TableObject](modeltable-object-excel.md) object.


## Property value

 **BOOL**


## See also


#### Other resources



[TableObject Object](modeltable-object-excel.md)

